Problem Note 56975: Deployment might fail with a "project load failed ..." error in SAS® Visual Scenario Designer
 |  |  |  |
In SAS Visual Scenario Designer, you can create a window by joining two or more tables. However, if you join tables that contain the same column names, then the deployment to SAS® Event Stream Processing fails with the following error:
Load status:project load failed:project project-name failed to start
An error similar to the following might be displayed in the SAS Visual Scenario Designer log. Example: COUNTRY is the column name in multiple join tables.
ERROR; 00002286; DF.ESP;(dfESPexpression_functions.cpp:290); dfESPexpression_function::setExpression()
for window YYY: Expression symbol T1_COUNTRY does not match an input event stream field name nor ESP_
reserved name for expression 'T1_COUNTRY'
ERROR; 00002287; DF.ESP;(dfESPexpression_window.cpp:225); dfESPexpression_window::validateFieldCalcMethod()
for window YYY: Call to setExpression() failed
for expression 'T1_COUNTRY'
ERROR; 00002288; DF.ESP; (dfESPwindow.cpp:1058); dfESPwindow::finalizeForRun() for window YYY:
Finalization failed
FATAL; 00002289; DF.ESP; (dfESPproject.cpp:270); dfESPproject::finalizeProject() for project XXX:
Failed finalizing continuous query: XXX
To work around the problem, drag only duplicate columns from the source table to the window data area.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Scenario Designer | Linux for x64 | 6.3 | 6.3_M1 | 9.4 TS1M3 | |
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-12-24 11:45:02 |
| Date Created: | 2015-10-30 15:09:42 |